mysql dba certification

Finally put OCP DBA's course all finished, tired Ah! Overall Oracle certification is worth the test. I have CCNP, MCSE certificate, but through the DBA examination, feel not only deepened the understanding of modern databases, but also enrich the knowledge structure of computer science. I think, in some ways, Oracle databases even have some operating system capabilities. Oracle's exams, there are quite a f

Label:Mysql DBA 20-day crash tutorial basic Knowledge 1.mysql compilation installation 2.mysql 3rd party Storage Engine Installation configuration method 3.mysql mainstream storage engine (Myisam/innodb/memory) features 4. String encoding knowledge 5.MySQL user accou

This article for me to learn old boy teacher MySQL DBA senior operation of the study notes, rookie a If there is a wrong place to write, please the great God more guidance, I will thank you very much. hehe ~7.6.1 MySQL Multi-instance common configuration scheme6.1.1 Multi-instance configuration file deployment scenarioImplement multi-instance scenarios by configu

of data is too general to have a problem. Mysqldump > linzhongniao.sql Sed –e ‘s#MyISAM#Innodb#g’linzhongniao.sql > linzhongniao2.sql Mysql (3) Method 3, modify with the mysql_convert_table_format command [[emailprotected] bin]# mysql_convert_table_format --user=root --password=123456 --socket=/data/3306/mysql.sock --engin student [[emailprotected] ~]# mysql -uroot -p123456 -S /data/3306/mysql.sock -e "us

DBA ranking first: Enterprise monitor simplifies MySQL database management. for database administrators, database monitoring plays an important role. Compared with commercial database products such as Oracle and SQL Server, open-source databases have consistently performed poorly in this regard, but after MySQL launched its Enterprise edition, It brings a good n

MySQL DBA in my heart, MySQLDBA in my mind Link: http://wangwei007.blog.51cto.com/68019/1718311 MySQL is a cross-platform open-source relational database management system. Currently, MySQL is widely used in small and medium websites on the Internet. Because of its small size, fast speed, and low total cost of ownershi

single character set.The collation commands are usually preceded by the names of the corresponding character sets and end with their own specific properties, such as collation Utf8_general_ci and Latin1_swedish_ci, respectively, that correspond to the collation of the UTF8 and latin1 character sets.When a collation is specific to a language, the middle part is the name of the language, such as Utf8_turkish_ci and Utf8_hungarian_ci, which represent Turkish and Hungarian in the UTF8 character set

experience and test, in order to more comprehensive test software deficiencies or existing problems.(3) RC versionRC version belongs to a production environment before the release of a small version or a candidate, is the beta version of the test results collected by the bug or defect of the collected information, to repair and improve the product after.(4) GA version:GA version belongs to the release of software products, also known as production version of the product, in general, the product

Conquer MySQL DBA for Linux system O M (I)-source code installation Conquer MySQL DBA for Linux system O M (I) source code installation Chapter 2 MySQL overview1.1 MySQL introductionMySQL is the most popular open-source SQL da

(); +---------------------+ | now() | +---------------------+ | 2018-01-18 20:14:43 | +---------------------+ 1 row in set (0.01 sec) 9.6 Viewing the table information contained in the current database Switch to the database to view [emailprotected] 08:1630->show tables; Empty set (0.00 sec) 空表，新库还没有建表 [emailprotected] 08:1742->show tables like ‘user‘; Empty set (0.00 sec) [emailprotected] 08:2016->show tables from zbf; 查询指定数据库的表 Empty set (0.00 sec) [emailprotected] 08:2030->show tables in

establishes enough database connections when it starts and makes these connections a pool of connections that are dynamically applied, used, and released by the program to the connection in the pool.5. Introduction to Storage Engine1. View the storage engine for the table: Show table status like ' table name '.2.innoDB Engine: MySQL5.5 later version, InnoDB is the default engine.Pros: 1. Disaster recovery Good 2. Support for all 4 levels of transactions. 3. Use row-level locks. 4. Implementing

] ~]# mysql -usystem -pzbf666 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.72-log Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respe

regarded as a bedroom, the entire server is a house, server hardware resources can be regarded as the house of the bathroom, kitchen is the public resources of the house. It's like being in a house in the north, so be sure to share the resources. In fact, many services can be many instances such as Nginx,apache,redias.5.1.2 MySQL multiple instances of the role and problems.5.1.2.1 Efficient use of server resourcesWhen a single server resource is left

(2) test data synchronization of the standby nodeFirst insert data in the Master node's DRBD file system, we insert 20 files[[emailprotected] data]# touch ‘seq 10‘[[emailprotected] data]# ls1 10 2 3 4 5 6 7 8 9 lost+found[[emailprotected] data]# touch `seq 10 20`To view the data synchronization of the standby node, we need to mount the DRBD storage device first, and we see that the data has been synchronized.[[emailprotected] ~]# mount/dev/sdb1/mntmount:you must specify the filesystem

First introduce the next Jane Chaoyang. is now working in Alibaba (China) Network Technology Co., Ltd. DBA Team Operation Department, Jenzhiang is the MySQL Technology essay contest third winner (winning article: the implementation of MySQL replication principle). He believes that his work experience will certainly be helpful to those who are now entering the

Tags: Web services Internet Database Linux How to become a MySQL DBAThe success of the Internet's rapid development has benefited from the support of MySQL database. MySQL itself is developing faster, with significant performance improvements, and allows traditional businesses to use MySQL to provide services. It seems

Label:Original URL Link: http://wangwei007.blog.51cto.com/68019/1718311 MySQL is a cross-platform open source relational database management system, currently MySQL is widely used in small and medium-sized websites on the internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownersh

performance_schemadrwx------. 2 mysql mysql 4096 1月 27 21:32 zbfWe see the cut is finished mysqlbin_zbf.000002, after cutting the data is written to mysqlbin_zbf.000002 inside write, now we have to deal with is mysqlbin_zbf.000001.(6) Generate Bin.sql fileIf there are more than one bin-log in the enterprise to restore all, but also have a lot of libraries and tables, Bin.sql is written in all the library

of the ID of the data is not continuous, because we set the following parameters in the my.cnf of the 3306 host, which means that the starting position of my ID field self-increment is 1 in the way of 2 at a time interval, so the data we insert above is self-increment at 2 intervals, then auto_increment_offset is the value equal to 2? Of course, the auto_increment_increment value of the parameter can also be set. auto_increment_increment= 2 自增的间隔如1 3 5 间隔为2 auto_increment_offset = 1 ID的初始位置 (

and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;‘ or ‘\h‘ for help. Type ‘\c‘ to clear the current input statement.mysql> select * from linzhongniao.test1;+----+-----------+| id | name |+----+-----------+| 1 | 张三 || 2 | 张三 || 3 | 我是谁|| 4 | 不认识|| 5 | 你是谁|+----+-----------+5 rows in set (0.00 sec) MySQL